package com.icebergteam.warfacewidget.data.sql;

import com.icebergteam.warfacewidget.AppManager;

public class ClanTable {
	// Constants
	// Table
	public static final String TABLE_NAME	= "clan";
	// Fields
	public static final String FIELD_ID				= "id ";
	public static final String FIELD_NAME			= "name ";
	public static final String FIELD_TAG			= "tag ";
	public static final String FIELD_ICON_PATH		= "icon_path ";
	public static final String FIELD_CREATE			= "created ";
	
	public ClanTable() {
		// Do nothing
	}
	
	public String createTableStr() {
		String field_id			= FIELD_ID			+ "integer primary key autoincrement";
		String field_name		= FIELD_NAME		+ "text";
		String field_tag		= FIELD_TAG			+ "varchar(45)";
		String field_icon_path	= FIELD_ICON_PATH	+ "text";
		String field_created	= FIELD_CREATE		+ "date";
		
		return AppManager.getDatabase().createTableStr(TABLE_NAME, field_id, field_name, field_tag, field_icon_path, field_created);
	}
}
